/*
 Navicat Premium Data Transfer

 Source Server         : wangjun
 Source Server Type    : MySQL
 Source Server Version : 50619
 Source Host           : localhost
 Source Database       : qingmu

 Target Server Type    : MySQL
 Target Server Version : 50619
 File Encoding         : utf-8

 Date: 11/25/2015 22:19:21 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `qm_notification_data`
-- ----------------------------
DROP TABLE IF EXISTS `qm_notification_data`;
CREATE TABLE `qm_notification_data` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `notification_id` int(11) NOT NULL,
  `data` text,
  `recipient_uid` int(11) NOT NULL,
  `sender_uid` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COMMENT='系统通知数据表';

-- ----------------------------
--  Records of `qm_notification_data`
-- ----------------------------
BEGIN;
INSERT INTO `qm_notification_data` VALUES ('3', '1', 'sdafas', '1', '2', '2015-11-25 13:20:57', '2015-11-25 13:20:57'), ('4', '2', 'dsfsdaf', '1', '3', '2015-11-25 13:21:07', '2015-11-25 13:21:07'), ('5', '1', '你好', '4', '1', '2015-11-25 16:01:47', '2015-11-25 16:01:47'), ('6', '1', '你好', '4', '1', '2015-11-25 16:01:47', '2015-11-25 16:01:47'), ('7', '1', '你好', '4', '1', '2015-11-25 16:09:51', '2015-11-25 16:09:51'), ('8', '1', '你好', '4', '1', '2015-11-25 16:09:51', '2015-11-25 16:09:51'), ('9', '1', '的', '4', '1', '2015-11-25 16:13:03', '2015-11-25 16:13:03'), ('10', '1', '发的', '4', '1', '2015-11-25 16:13:57', '2015-11-25 16:13:57'), ('11', '1', '地方', '4', '1', '2015-11-25 16:15:49', '2015-11-25 16:15:49'), ('12', '1', 'vvvv', '4', '1', '2015-11-25 16:16:10', '2015-11-25 16:16:10'), ('13', '1', 'fdf', '4', '1', '2015-11-25 16:17:20', '2015-11-25 16:17:20'), ('14', '1', 'fdf', '4', '1', '2015-11-25 16:17:38', '2015-11-25 16:17:38'), ('15', '1', 'fkjl', '4', '1', '2015-11-25 16:18:18', '2015-11-25 16:18:18'), ('16', '1', 'fkjl', '4', '1', '2015-11-25 16:18:38', '2015-11-25 16:18:38'), ('17', '1', 'fdsf', '4', '1', '2015-11-25 16:19:33', '2015-11-25 16:19:33'), ('18', '1', 'dsf', '4', '1', '2015-11-25 16:20:10', '2015-11-25 16:20:10'), ('19', '1', 'fff', '4', '1', '2015-11-25 16:20:19', '2015-11-25 16:20:19'), ('20', '1', 'fdf', '4', '1', '2015-11-25 16:22:27', '2015-11-25 16:22:27'), ('21', '1', 'fdf', '4', '1', '2015-11-25 16:22:44', '2015-11-25 16:22:44'), ('22', '1', 'ddd', '4', '1', '2015-11-25 16:24:08', '2015-11-25 16:24:08'), ('23', '1', 'ggg', '4', '1', '2015-11-25 16:24:19', '2015-11-25 16:24:19'), ('24', '1', 'dfsa', '4', '1', '2015-11-25 16:25:11', '2015-11-25 16:25:11');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
